﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_PASSWORD_UP')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_PASSWORD_UP
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_USER_PASSWORD_UP] 
(
    @TU_ID Integer,
    @TU_PASSWORD Varchar(50) 
)
AS
	UPDATE TB_USER
	SET TU_PASSWORD = @TU_PASSWORD
	WHERE TU_ID = @TU_ID


GO

GRANT EXEC ON dbo.PRC_TB_USER_PASSWORD_UP TO PUBLIC

GO

